package com.tangula.web.kashine.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import com.tangula.web.kashine.entity.UpDateStudentForm;
@Repository
public interface UpDateSudentFormRepository  extends JpaRepository<UpDateStudentForm, String>{
	@Query(nativeQuery=true,value="SELECT c.class_id AS class_id,c.student_id AS student_id,c.student_name_in_class AS student_name,c.student_des_in_class AS student_desc,c.student_image AS student_image FROM t_classstudentref c WHERE c.class_id = :classId  LIMIT  :size")
	List<UpDateStudentForm> showStudentInClass(@Param("classId")String condition,@Param("size")int size);

}
